package com.yellowpage.ndc.data;

import java.util.Date;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
import org.hibernate.annotations.GenericGenerator;

/**
 * Listing entity. @author MyEclipse Persistence Tools
 */
@Entity
@Table(name = "db_ndc.LISTING")
public class Listing implements java.io.Serializable {

	// Fields

	private Long listId;
	private String custId;
	private Long addrId;
	private String subname1;
	private String subname2;
	private String subname3;
	private String subname4;
	private String tel;
	private String telExt;
	private String faxFlag;
	private Short sb;
	private String source;
	private Integer listOrder;
	private String note;
	private Byte listStatus;
	private Date modifyTime;
	private Long modifyEmpId;
	private Long findwayId;

	// Constructors

	/** default constructor */
	public Listing() {
	}

	/** minimal constructor */
	public Listing(Long addrId, String tel, Integer listOrder, Long findwayId) {
		this.addrId = addrId;
		this.tel = tel;
		this.listOrder = listOrder;
		this.findwayId = findwayId;
	}

	/** full constructor */
	public Listing(String custId, Long addrId, String subname1,
			String subname2, String subname3, String subname4, String tel,
			String telExt, String faxFlag, Short sb, String source,
			Integer listOrder, String note, Byte listStatus, Date modifyTime,
			Long modifyEmpId, Long findwayId) {
		this.custId = custId;
		this.addrId = addrId;
		this.subname1 = subname1;
		this.subname2 = subname2;
		this.subname3 = subname3;
		this.subname4 = subname4;
		this.tel = tel;
		this.telExt = telExt;
		this.faxFlag = faxFlag;
		this.sb = sb;
		this.source = source;
		this.listOrder = listOrder;
		this.note = note;
		this.listStatus = listStatus;
		this.modifyTime = modifyTime;
		this.modifyEmpId = modifyEmpId;
		this.findwayId = findwayId;
	}

	// Property accessors
	@GenericGenerator(name = "generator", strategy = "identity")
	@Id
	@GeneratedValue(generator = "generator")
	@Column(name = "LIST_ID", unique = true, nullable = false, precision = 18, scale = 0)
	public Long getListId() {
		return this.listId;
	}

	public void setListId(Long listId) {
		this.listId = listId;
	}

	@Column(name = "CUST_ID", length = 14)
	public String getCustId() {
		return this.custId;
	}

	public void setCustId(String custId) {
		this.custId = custId;
	}

	@Column(name = "ADDR_ID", nullable = false, precision = 18, scale = 0)
	public Long getAddrId() {
		return this.addrId;
	}

	public void setAddrId(Long addrId) {
		this.addrId = addrId;
	}

	@Column(name = "SUBNAME1", length = 64)
	public String getSubname1() {
		return this.subname1;
	}

	public void setSubname1(String subname1) {
		this.subname1 = subname1;
	}

	@Column(name = "SUBNAME2", length = 64)
	public String getSubname2() {
		return this.subname2;
	}

	public void setSubname2(String subname2) {
		this.subname2 = subname2;
	}

	@Column(name = "SUBNAME3", length = 64)
	public String getSubname3() {
		return this.subname3;
	}

	public void setSubname3(String subname3) {
		this.subname3 = subname3;
	}

	@Column(name = "SUBNAME4", length = 64)
	public String getSubname4() {
		return this.subname4;
	}

	public void setSubname4(String subname4) {
		this.subname4 = subname4;
	}

	@Column(name = "TEL", nullable = false, length = 20)
	public String getTel() {
		return this.tel;
	}

	public void setTel(String tel) {
		this.tel = tel;
	}

	@Column(name = "TEL_EXT", length = 10)
	public String getTelExt() {
		return this.telExt;
	}

	public void setTelExt(String telExt) {
		this.telExt = telExt;
	}

	@Column(name = "FAX_FLAG", length = 1)
	public String getFaxFlag() {
		return this.faxFlag;
	}

	public void setFaxFlag(String faxFlag) {
		this.faxFlag = faxFlag;
	}

	@Column(name = "SB", precision = 4, scale = 0)
	public Short getSb() {
		return this.sb;
	}

	public void setSb(Short sb) {
		this.sb = sb;
	}

	@Column(name = "SOURCE", length = 96)
	public String getSource() {
		return this.source;
	}

	public void setSource(String source) {
		this.source = source;
	}

	@Column(name = "LIST_ORDER", nullable = false, precision = 6, scale = 0)
	public Integer getListOrder() {
		return this.listOrder;
	}

	public void setListOrder(Integer listOrder) {
		this.listOrder = listOrder;
	}

	@Column(name = "NOTE", length = 256)
	public String getNote() {
		return this.note;
	}

	public void setNote(String note) {
		this.note = note;
	}

	@Column(name = "LIST_STATUS", precision = 2, scale = 0)
	public Byte getListStatus() {
		return this.listStatus;
	}

	public void setListStatus(Byte listStatus) {
		this.listStatus = listStatus;
	}

	@Temporal(TemporalType.TIMESTAMP)
	@Column(name = "MODIFY_TIME", length = 0)
	public Date getModifyTime() {
		return this.modifyTime;
	}

	public void setModifyTime(Date modifyTime) {
		this.modifyTime = modifyTime;
	}

	@Column(name = "MODIFY_EMP_ID", precision = 18, scale = 0)
	public Long getModifyEmpId() {
		return this.modifyEmpId;
	}

	public void setModifyEmpId(Long modifyEmpId) {
		this.modifyEmpId = modifyEmpId;
	}

	@Column(name = "FINDWAY_ID", nullable = false, precision = 18, scale = 0)
	public Long getFindwayId() {
		return this.findwayId;
	}

	public void setFindwayId(Long findwayId) {
		this.findwayId = findwayId;
	}

}